/**
 * @description: 项目管理
 * @version: 0.0.1
 * @author: ljr
 * @Date: 2023-09-12 11:33:58
 */
import {
  Table,
  Model,
  Column,
  CreatedAt,
  UpdatedAt,
  DataType,
} from 'sequelize-typescript';

@Table({ tableName: 'orders_records' })
export class OrdRecord extends Model {
  @Column({
    primaryKey: true,       //主键
    autoIncrement: true,    //自增
    comment: "自增id"       //注释:只在代码中有效
  })
  id: number;
  
  @Column(DataType.TEXT)
  order_name: string; //订单名称

  @Column(DataType.TEXT)
  order_details: string; //订单详情

  @Column(DataType.TEXT)
  order_id: string; //订单编号

  @Column(DataType.TEXT)
  remarks: string; //备注

  @Column(DataType.TEXT)
  belong_date: string;     //归属日期

  @Column(DataType.INTEGER)
  created_userid: number;//负责人名称

  @Column(DataType.TEXT)
  create_username: string; //创建人名称

  @CreatedAt
  created_at: Date; 

  @UpdatedAt
  updated_at: Date;

  @Column(DataType.TEXT)
  is_del: number;

  @Column(DataType.TEXT)
  brand_name: string; //品牌名称

  @Column(DataType.TEXT)
  chuanyun_object_id: string; //氚云订单记录ObjectId

  @Column(DataType.TEXT)
  chuanyun_pm_name: string; //主PM

  @Column(DataType.TEXT)
  chuanyun_pm_unionid: string; //主PM钉钉unionid

  @Column(DataType.TEXT)
  chuanyun_owner_name: string; //拥有者

  @Column(DataType.TEXT)
  chuanyun_owner_unionid: string; //拥有者钉钉unionid

  @Column(DataType.TEXT)
  chuanyun_start_time: string; //启动日期

  @Column(DataType.TEXT)
  chuanyun_end_time: string; //完结日期
}